using System;
using System.Collections.Generic;
using System.Text;
using QLKS.HeThongBUS;
using System.Data;
using System.Data.OleDb;


namespace QLKS.HeThongDAO
{
    public class InHD_DAO
    {
        public static DataTable ThongTinHD(string maph,int mahd)
        {
            string sql = "SELECT HoaDon.MaHoaDon,CTThuePhong.MaPhong,NgayThuePhong,NgayTraPhong,SoLuongNguoi,TienThuePhong,TenNhanVien,KhachDangKy,ThanhTien,TenKhachHang,TenDichVu,SoLuong,TienDichVu,GiaDichVu FROM DichVu,HoaDon,KhachHang,CTDichVu,CTThuePhong,NhanVien where DichVu.MaDichVu=CTDichVu.MaDichVu and CTDichVu.MaPhong = CTThuePhong.MaPhong and CTThuePhong.MaHoaDon = HoaDon.MaHoaDon and HoaDon.KhachDangKy = KhachHang.MaKhachHang and HoaDon.NguoiLapHoaDon =NhanVien.MaNhanVien and CTThuePhong.MaPhong ='"+ maph +"'and HoaDon.MaHoaDon="+mahd+"";
            return Config.AccessHelper.ExecuteQuery(sql);
        }
    }
}
